#coding:utf-8
import cx_Oracle
from orac_con import *
#参数以字典的形式表示
pr = {'name':'tyy0414'}
sql = 'select * from X_USER where username=:name'
#execute(sql,params) execute(sql,params=value) 
#cr.execute(sql,pr)
cr.execute(sql,name='tyy0414')
rs = cr.fetchall()
print('结果为%s' %rs)
db.close()